<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta charset="utf-8"/>
    <title>爬虫</title>
    <style type="text/css">
        table.gridtable {
            font-family: verdana, arial, sans-serif;
            font-size: 11px;
            color: #333333;
            border-width: 1px;
            border-color: #666666;
            border-collapse: collapse;
        }

        table.gridtable th {
            border-width: 1px;
            padding: 8px;
            border-style: solid;
            border-color: #666666;
            background-color: #dedede;
        }

        table.gridtable td {
            border-width: 1px;
            padding: 8px;
            border-style: solid;
            border-color: #666666;
            background-color: #ffffff;
        }
    </style>
</head>

<body>
    <br/>
    <table class="gridtable">
        <thead>
        <tr>
            <td colspan="7">House 房屋</td>
        </tr>
        <tr>
            <td>字段</td>
            <td>字段中文名</td>
            <td>java类型</td>
            <td>数据库名称</td>
            <td>数据库类型</td>
            <td>长度</td>
            <td>描述</td>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>主键</td>
            <td>Integer</td>
            <td>id</td>
            <td>INT</td>
            <td>10</td>
            <td>主键</td>
        </tr>
        <tr>
            <td>xiaoqu</td>
            <td>小区</td>
            <td>String</td>
            <td>xiaoqu</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>小区</td>
        </tr>
        <tr>
            <td>total</td>
            <td>总价</td>
            <td>Float</td>
            <td>total</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>总价</td>
        </tr>
        <tr>
            <td>unitPrice</td>
            <td>单价</td>
            <td>Float</td>
            <td>unit_price</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>单价</td>
        </tr>
        <tr>
            <td>followCount</td>
            <td>关注人数</td>
            <td>Integer</td>
            <td>follow_count</td>
            <td>INT</td>
            <td>10</td>
            <td>关注人数</td>
        </tr>
        <tr>
            <td>lookCount</td>
            <td>带看人数</td>
            <td>Integer</td>
            <td>look_count</td>
            <td>INT</td>
            <td>10</td>
            <td>带看人数</td>
        </tr>
        <tr>
            <td>publishTime</td>
            <td>发布时间</td>
            <td>String</td>
            <td>publish_time</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>发布时间</td>
        </tr>
        <tr>
            <td>positionInfo</td>
            <td>位置详情</td>
            <td>String</td>
            <td>position_info</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>位置详情</td>
        </tr>
        <tr>
            <td>houseTag</td>
            <td>房源标签</td>
            <td>String</td>
            <td>house_tag</td>
            <td>VARCHAR</td>
            <td>100</td>
            <td>房源标签</td>
        </tr>
        <tr>
            <td>locationOne</td>
            <td>一级地区</td>
            <td>String</td>
            <td>location_one</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>一级地区</td>
        </tr>
        <tr>
            <td>locationTwo</td>
            <td>二级地区</td>
            <td>String</td>
            <td>location_two</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>二级地区</td>
        </tr>
        <tr>
            <td>houseType</td>
            <td>房屋户型</td>
            <td>String</td>
            <td>house_type</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>房屋户型</td>
        </tr>
        <tr>
            <td>houseArea</td>
            <td>建筑面积</td>
            <td>Float</td>
            <td>house_area</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>建筑面积</td>
        </tr>
        <tr>
            <td>houseFacing</td>
            <td>房子朝向</td>
            <td>String</td>
            <td>house_facing</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>房子朝向</td>
        </tr>
        <tr>
            <td>decorationSituation</td>
            <td>装修情况</td>
            <td>String</td>
            <td>decoration_situation</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>装修情况</td>
        </tr>
        <tr>
            <td>haveElevator</td>
            <td>配备电梯</td>
            <td>String</td>
            <td>have_elevator</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>配备电梯</td>
        </tr>
        <tr>
            <td>houseFloor</td>
            <td>所在楼层</td>
            <td>String</td>
            <td>house_floor</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>所在楼层</td>
        </tr>
        <tr>
            <td>totalFloor</td>
            <td>总楼层</td>
            <td>Integer</td>
            <td>total_floor</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>总楼层</td>
        </tr>
        <tr>
            <td>buildingYears</td>
            <td>修建年代</td>
            <td>Integer</td>
            <td>building_years</td>
            <td>SMALLINT</td>
            <td>5</td>
            <td>修建年代</td>
        </tr>
        <tr>
            <td>buildingType</td>
            <td>建筑类型</td>
            <td>String</td>
            <td>building_type</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>建筑类型</td>
        </tr>
        <tr>
            <td>title</td>
            <td>标题</td>
            <td>String</td>
            <td>title</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>标题</td>
        </tr>
        <tr>
            <td>houseId</td>
            <td>房屋编号</td>
            <td>String</td>
            <td>house_id</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>房屋编号</td>
        </tr>
        <tr>
            <td>yn</td>
            <td>是否有效</td>
            <td>Integer</td>
            <td>yn</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>是否有效(0无效,1有效)</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>备注</td>
            <td>String</td>
            <td>remark</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>备注</td>
        </tr>
        <tr>
            <td>modifiedUser</td>
            <td>修改人</td>
            <td>String</td>
            <td>modified_user</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>修改人</td>
        </tr>
        <tr>
            <td>createdDate</td>
            <td>创建时间</td>
            <td>Date</td>
            <td>created_date</td>
            <td>DATETIME</td>
            <td>19</td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>modifiedDate</td>
            <td>修改时间</td>
            <td>Date</td>
            <td>modified_date</td>
            <td>TIMESTAMP</td>
            <td>19</td>
            <td>修改时间</td>
        </tr>
    </tbody>
    </table>
    <br/>
    <table class="gridtable">
        <thead>
        <tr>
            <td colspan="7">HouseDetailDay 房屋每日明细</td>
        </tr>
        <tr>
            <td>字段</td>
            <td>字段中文名</td>
            <td>java类型</td>
            <td>数据库名称</td>
            <td>数据库类型</td>
            <td>长度</td>
            <td>描述</td>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>主键</td>
            <td>Integer</td>
            <td>id</td>
            <td>INT</td>
            <td>10</td>
            <td>主键</td>
        </tr>
        <tr>
            <td>crawlerDate</td>
            <td>爬取日期</td>
            <td>String</td>
            <td>crawler_date</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>爬取日期</td>
        </tr>
        <tr>
            <td>total</td>
            <td>总价</td>
            <td>Float</td>
            <td>total</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>总价</td>
        </tr>
        <tr>
            <td>unitPrice</td>
            <td>单价</td>
            <td>Float</td>
            <td>unit_price</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>单价</td>
        </tr>
        <tr>
            <td>followCount</td>
            <td>关注人数</td>
            <td>Integer</td>
            <td>follow_count</td>
            <td>INT</td>
            <td>10</td>
            <td>关注人数</td>
        </tr>
        <tr>
            <td>lookCount</td>
            <td>带看人数</td>
            <td>Integer</td>
            <td>look_count</td>
            <td>INT</td>
            <td>10</td>
            <td>带看人数</td>
        </tr>
        <tr>
            <td>xiaoqu</td>
            <td>小区</td>
            <td>String</td>
            <td>xiaoqu</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>小区</td>
        </tr>
        <tr>
            <td>title</td>
            <td>标题</td>
            <td>String</td>
            <td>title</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>标题</td>
        </tr>
        <tr>
            <td>houseArea</td>
            <td>建筑面积</td>
            <td>Float</td>
            <td>house_area</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>建筑面积</td>
        </tr>
        <tr>
            <td>houseId</td>
            <td>房屋编号</td>
            <td>String</td>
            <td>house_id</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>房屋编号</td>
        </tr>
        <tr>
            <td>yn</td>
            <td>是否有效</td>
            <td>Integer</td>
            <td>yn</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>是否有效(0无效,1有效)</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>备注</td>
            <td>String</td>
            <td>remark</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>备注</td>
        </tr>
        <tr>
            <td>modifiedUser</td>
            <td>修改人</td>
            <td>String</td>
            <td>modified_user</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>修改人</td>
        </tr>
        <tr>
            <td>createdDate</td>
            <td>创建时间</td>
            <td>Date</td>
            <td>created_date</td>
            <td>DATETIME</td>
            <td>19</td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>modifiedDate</td>
            <td>修改时间</td>
            <td>Date</td>
            <td>modified_date</td>
            <td>TIMESTAMP</td>
            <td>19</td>
            <td>修改时间</td>
        </tr>
    </tbody>
    </table>
    <br/>
    <table class="gridtable">
        <thead>
        <tr>
            <td colspan="7">IpProxy ip代理</td>
        </tr>
        <tr>
            <td>字段</td>
            <td>字段中文名</td>
            <td>java类型</td>
            <td>数据库名称</td>
            <td>数据库类型</td>
            <td>长度</td>
            <td>描述</td>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>主键</td>
            <td>Integer</td>
            <td>id</td>
            <td>INT</td>
            <td>10</td>
            <td>主键</td>
        </tr>
        <tr>
            <td>ip</td>
            <td>ip</td>
            <td>String</td>
            <td>ip</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>ip</td>
        </tr>
        <tr>
            <td>port</td>
            <td>端口</td>
            <td>Integer</td>
            <td>port</td>
            <td>INT</td>
            <td>10</td>
            <td>端口</td>
        </tr>
        <tr>
            <td>proxyType</td>
            <td>代理类型</td>
            <td>Integer</td>
            <td>proxy_type</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>代理类型(1:透明 2:匿名 3:高匿)</td>
        </tr>
        <tr>
            <td>available</td>
            <td>是否可用</td>
            <td>Integer</td>
            <td>available</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>是否可用</td>
        </tr>
        <tr>
            <td>yn</td>
            <td>是否有效</td>
            <td>Integer</td>
            <td>yn</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>是否有效(0无效,1有效)</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>备注</td>
            <td>String</td>
            <td>remark</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>备注</td>
        </tr>
        <tr>
            <td>modifiedUser</td>
            <td>修改人</td>
            <td>String</td>
            <td>modified_user</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>修改人</td>
        </tr>
        <tr>
            <td>createdDate</td>
            <td>创建时间</td>
            <td>Date</td>
            <td>created_date</td>
            <td>DATETIME</td>
            <td>19</td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>modifiedDate</td>
            <td>修改时间</td>
            <td>Date</td>
            <td>modified_date</td>
            <td>TIMESTAMP</td>
            <td>19</td>
            <td>修改时间</td>
        </tr>
    </tbody>
    </table>
    <br/>
    <table class="gridtable">
        <thead>
        <tr>
            <td colspan="7">Xiaoqu 小区</td>
        </tr>
        <tr>
            <td>字段</td>
            <td>字段中文名</td>
            <td>java类型</td>
            <td>数据库名称</td>
            <td>数据库类型</td>
            <td>长度</td>
            <td>描述</td>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>主键</td>
            <td>Integer</td>
            <td>id</td>
            <td>INT</td>
            <td>10</td>
            <td>主键</td>
        </tr>
        <tr>
            <td>xiaoqu</td>
            <td>小区名称</td>
            <td>String</td>
            <td>xiaoqu</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>小区名称</td>
        </tr>
        <tr>
            <td>xiaoquId</td>
            <td>小区编号</td>
            <td>String</td>
            <td>xiaoqu_id</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>小区编号</td>
        </tr>
        <tr>
            <td>unitPrice</td>
            <td>单价</td>
            <td>Float</td>
            <td>unit_price</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>单价</td>
        </tr>
        <tr>
            <td>sellCount</td>
            <td>在售数量</td>
            <td>Integer</td>
            <td>sell_count</td>
            <td>INT</td>
            <td>10</td>
            <td>在售数量</td>
        </tr>
        <tr>
            <td>dealCount</td>
            <td>最近成交数</td>
            <td>Integer</td>
            <td>deal_count</td>
            <td>INT</td>
            <td>10</td>
            <td>最近成交数</td>
        </tr>
        <tr>
            <td>leaseCount</td>
            <td>正在出租</td>
            <td>Integer</td>
            <td>lease_count</td>
            <td>INT</td>
            <td>10</td>
            <td>正在出租</td>
        </tr>
        <tr>
            <td>houseTypeCount</td>
            <td>户型总数</td>
            <td>Integer</td>
            <td>house_type_count</td>
            <td>INT</td>
            <td>10</td>
            <td>户型总数</td>
        </tr>
        <tr>
            <td>locationOne</td>
            <td>一级地区</td>
            <td>String</td>
            <td>location_one</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>一级地区</td>
        </tr>
        <tr>
            <td>locationTwo</td>
            <td>二级地区</td>
            <td>String</td>
            <td>location_two</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>二级地区</td>
        </tr>
        <tr>
            <td>buildingType</td>
            <td>建筑类型</td>
            <td>String</td>
            <td>building_type</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>建筑类型</td>
        </tr>
        <tr>
            <td>buildingYears</td>
            <td>修建年代</td>
            <td>Integer</td>
            <td>building_years</td>
            <td>SMALLINT</td>
            <td>5</td>
            <td>修建年代</td>
        </tr>
        <tr>
            <td>houseTag</td>
            <td>房源标签</td>
            <td>String</td>
            <td>house_tag</td>
            <td>VARCHAR</td>
            <td>100</td>
            <td>房源标签</td>
        </tr>
        <tr>
            <td>yn</td>
            <td>是否有效</td>
            <td>Integer</td>
            <td>yn</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>是否有效(0无效,1有效)</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>备注</td>
            <td>String</td>
            <td>remark</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>备注</td>
        </tr>
        <tr>
            <td>modifiedUser</td>
            <td>修改人</td>
            <td>String</td>
            <td>modified_user</td>
            <td>VARCHAR</td>
            <td>255</td>
            <td>修改人</td>
        </tr>
        <tr>
            <td>createdDate</td>
            <td>创建时间</td>
            <td>Date</td>
            <td>created_date</td>
            <td>DATETIME</td>
            <td>19</td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>modifiedDate</td>
            <td>修改时间</td>
            <td>Date</td>
            <td>modified_date</td>
            <td>TIMESTAMP</td>
            <td>19</td>
            <td>修改时间</td>
        </tr>
    </tbody>
    </table>
    <br/>
    <table class="gridtable">
        <thead>
        <tr>
            <td colspan="7">XiaoquDetailDay 小区每日明细</td>
        </tr>
        <tr>
            <td>字段</td>
            <td>字段中文名</td>
            <td>java类型</td>
            <td>数据库名称</td>
            <td>数据库类型</td>
            <td>长度</td>
            <td>描述</td>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>主键</td>
            <td>Integer</td>
            <td>id</td>
            <td>INT</td>
            <td>10</td>
            <td>主键</td>
        </tr>
        <tr>
            <td>crawlerDate</td>
            <td>爬取日期</td>
            <td>String</td>
            <td>crawler_date</td>
            <td>VARCHAR</td>
            <td>10</td>
            <td>爬取日期</td>
        </tr>
        <tr>
            <td>unitPrice</td>
            <td>单价</td>
            <td>Float</td>
            <td>unit_price</td>
            <td>FLOAT</td>
            <td>12</td>
            <td>单价</td>
        </tr>
        <tr>
            <td>sellCount</td>
            <td>在售数量</td>
            <td>Integer</td>
            <td>sell_count</td>
            <td>INT</td>
            <td>10</td>
            <td>在售数量</td>
        </tr>
        <tr>
            <td>dealCount</td>
            <td>最近成交数</td>
            <td>Integer</td>
            <td>deal_count</td>
            <td>INT</td>
            <td>10</td>
            <td>最近成交数</td>
        </tr>
        <tr>
            <td>leaseCount</td>
            <td>正在出租</td>
            <td>Integer</td>
            <td>lease_count</td>
            <td>INT</td>
            <td>10</td>
            <td>正在出租</td>
        </tr>
        <tr>
            <td>xiaoquId</td>
            <td>小区编号</td>
            <td>String</td>
            <td>xiaoqu_id</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>小区编号</td>
        </tr>
        <tr>
            <td>yn</td>
            <td>是否有效</td>
            <td>Integer</td>
            <td>yn</td>
            <td>TINYINT</td>
            <td>3</td>
            <td>是否有效(0无效,1有效)</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>备注</td>
            <td>String</td>
            <td>remark</td>
            <td>VARCHAR</td>
            <td>50</td>
            <td>备注</td>
        </tr>
        <tr>
            <td>modifiedUser</td>
            <td>修改人</td>
            <td>String</td>
            <td>modified_user</td>
            <td>VARCHAR</td>
            <td>20</td>
            <td>修改人</td>
        </tr>
        <tr>
            <td>createdDate</td>
            <td>创建时间</td>
            <td>Date</td>
            <td>created_date</td>
            <td>DATETIME</td>
            <td>19</td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>modifiedDate</td>
            <td>修改时间</td>
            <td>Date</td>
            <td>modified_date</td>
            <td>TIMESTAMP</td>
            <td>19</td>
            <td>修改时间</td>
        </tr>
    </tbody>
    </table>
</body>
</html>
